<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" interactivePageBreakByFrame="true" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-4-13. 8:9:11-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Chargeback']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>VM End to End NFS and CIFS Path</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total ESX Hosts</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton1" refQuery="VM NFS End to End Path">
			<contents><textItem><dataSource><dataItemValue refDataItem="ESX Host Count"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total NFS Shares</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton2" refQuery="VM NFS End to End Path">
			<contents><textItem><dataSource><dataItemValue refDataItem="NFS Share Count"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Total CIFS Shares</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton3" refQuery="VM NFS End to End Path">
			<contents><textItem><dataSource><dataItemValue refDataItem="CIFS Share Count"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Capacity in Data Stores</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton4" refQuery="VM NFS End to End Path">
			<contents><textItem><dataSource><dataItemValue refDataItem="Total Datastore Capacity TB"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,### TB"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Provisioned to VMs</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton5" refQuery="VM NFS End to End Path">
			<contents><textItem><dataSource><dataItemValue refDataItem="Total Provisioned TB"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,### TB"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Data Store Available</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton6" refQuery="VM NFS End to End Path">
			<contents><textItem><dataSource><dataItemValue refDataItem="Available TB"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/><dataFormat><numberFormat pattern="###,### TB"/></dataFormat></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-bottom:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>NFS or CIFS Share to Data Store Path</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List1" refQuery="VM NFS End to End Path" rowsPerPage="5000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Cluster Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Cluster Name"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="Cluster Name"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="ESX Server"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:150px;word-wrap:break-word;word-break:break-all;text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="ESX Server"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="Cluster Name"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Storage"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Storage"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="Storage"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Share"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Share"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Protocol"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Protocol"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Capacity GB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Capacity GB"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Data Store"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Data Store"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Data Store Capacity GB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Data Store Capacity GB"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Data Store Used GB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Data Store Used GB"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><listGroups><listGroup refDataItem="Cluster Name"><listFooter><listRows><listRow><rowCells><rowCell colSpan="5"><contents><textItem><dataSource><dataItemValue refDataItem="Cluster Name"/></dataSource></textItem><textItem><dataSource><staticValue> - </staticValue></dataSource></textItem><textItem><dataSource><staticValue>Total</staticValue></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="of"/></defaultStyles><CSS value="background-color:white;color:#454545"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Capacity GB)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><dataFormat><numberFormat decimalSize="2"/></dataFormat><CSS value="background-color:white;color:#454545"/></style></rowCell><rowCell colSpan="1"><contents/><style><defaultStyles><defaultStyle refStyle="of"/></defaultStyles><CSS value="background-color:white;color:#808080"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Data Store Capacity GB)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><dataFormat><numberFormat decimalSize="2"/></dataFormat><CSS value="background-color:white;color:#454545"/></style></rowCell><rowCell colSpan="1"><contents><textItem><dataSource><dataItemValue refDataItem="Total(Data Store Used GB)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><dataFormat><numberFormat decimalSize="2"/></dataFormat><CSS value="background-color:white;color:#454545"/></style></rowCell></rowCells></listRow></listRows></listFooter></listGroup><listGroup refDataItem="Storage"/></listGroups><listOverallGroup><listFooter><listRows><listRow><rowCells><rowCell colSpan="5"><contents><textItem><dataSource><staticValue>Overall</staticValue></dataSource></textItem><textItem><dataSource><staticValue> - </staticValue></dataSource></textItem><textItem><dataSource><staticValue>Total</staticValue></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="if"/></defaultStyles><CSS value="background-color:white;color:#454545"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Capacity GB)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="is"/></defaultStyles><dataFormat><numberFormat decimalSize="2"/></dataFormat><CSS value="background-color:white;color:#454545"/></style></rowCell><rowCell colSpan="1"><contents/><style><defaultStyles><defaultStyle refStyle="if"/></defaultStyles><CSS value="background-color:white;color:#454545"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Data Store Capacity GB)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="is"/></defaultStyles><dataFormat><numberFormat decimalSize="2"/></dataFormat><CSS value="background-color:white;color:#454545"/></style></rowCell><rowCell colSpan="1"><contents><textItem><dataSource><dataItemValue refDataItem="Total(Data Store Used GB)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="is"/></defaultStyles><dataFormat><numberFormat decimalSize="2"/></dataFormat><CSS value="background-color:white;color:#454545"/></style></rowCell></rowCells></listRow></listRows></listFooter></listOverallGroup></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>NFS or CIFS Data Store VM Guest Inventory</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List2" refQuery="VM NFS End to End Path" rowsPerPage="5000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Cluster Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Cluster Name"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="Cluster Name"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="VM Guest"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="VM Guest"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Provisioned GB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Provisioned GB"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used GB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Used GB"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><listGroups><listGroup refDataItem="Cluster Name"/></listGroups></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;vertical-align:top"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:10px;padding-left:10px;padding-bottom:10px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.905Z"/></XMLAttributes><reportName>7.9 VM End to End NFS and CIFS Path</reportName><queries><query name="VM NFS End to End Path">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL1">
			<sqlText>SELECT
dwh_inventory.hv_server.clustername as 'Cluster Name',
GROUP_CONCAT(DISTINCT SUBSTR(dwh_inventory.host.name,1,LOCATE('.', dwh_inventory.host.name)-1) ORDER BY SUBSTR(dwh_inventory.host.name,1,LOCATE('.', dwh_inventory.host.name)-1) SEPARATOR ' | ') as 'ESX Server',
dwh_inventory.storage.name as 'Storage',
dwh_inventory.hv_nas_share.sharePath as 'Share',
dwh_inventory.hv_nas_share.type as 'Protocol',
dwh_inventory.hv_nas_share.capacityMB/1024 as 'Capacity GB',
dwh_inventory.hv_data_store.name as 'Data Store',
dwh_inventory.hv_data_store.capacityMB/1024 as 'Data Store Capacity GB',
dwh_inventory.hv_data_store.usedCapacityMB/1024 as 'Data Store Used GB',
vm.VMGuest as 'VM Guest',
vm.provisionedGB as 'Provisioned GB',
vm.usedGB as 'Used GB'

FROM            dwh_inventory.hv_data_store
JOIN            dwh_inventory.hv_datastore_to_nas_share
ON              dwh_inventory.hv_datastore_to_nas_share.datastoreid=dwh_inventory.hv_data_store.id
JOIN            dwh_inventory.hv_nas_share
ON              dwh_inventory.hv_nas_share.id=dwh_inventory.hv_datastore_to_nas_share.nasshareid
JOIN            dwh_inventory.hv_nas_share_to_share
ON              dwh_inventory.hv_nas_share_to_share.nasshareid=dwh_inventory.hv_nas_share.id
JOIN            dwh_inventory.storage
ON              dwh_inventory.hv_nas_share_to_share.storageid=dwh_inventory.storage.id
LEFT JOIN       dwh_inventory.hv_host_to_nas_share
ON              dwh_inventory.hv_host_to_nas_share.nasshareid=dwh_inventory.hv_nas_share.id
LEFT JOIN       dwh_inventory.host
ON              dwh_inventory.host.id=dwh_inventory.hv_host_to_nas_share.hostid
LEFT JOIN       dwh_inventory.hv_server
ON              dwh_inventory.hv_server.hostid=dwh_inventory.host.id

JOIN
(
SELECT
dwh_inventory.hv_server.clustername as clusterName,
dwh_inventory.hv_virtual_machine.name as VMGuest,
dwh_inventory.hv_data_store.id as datastoreid,
dwh_inventory.hv_virtual_machine.provisionedCapacityMB/1024 as provisionedGB,
dwh_inventory.hv_virtual_machine.usedCapacityMB/1024 as usedGB

FROM 	dwh_inventory.hv_virtual_machine
JOIN	dwh_inventory.host
ON	dwh_inventory.hv_virtual_machine.hostid=dwh_inventory.host.id
JOIN	dwh_inventory.hv_server
ON	dwh_inventory.hv_server.hostid=dwh_inventory.host.id
JOIN	dwh_inventory.hv_data_store
ON	dwh_inventory.hv_data_store.id=dwh_inventory.hv_virtual_machine.datastoreid

GROUP BY dwh_inventory.hv_server.clustername, dwh_inventory.hv_virtual_machine.name
) vm ON vm.datastoreid=dwh_inventory.hv_data_store.id



GROUP BY dwh_inventory.hv_server.clustername, dwh_inventory.hv_data_store.name, dwh_inventory.hv_nas_share.sharePath
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Cluster Name"/><mdProjectedItem name="ESX Server"/><mdProjectedItem name="Storage"/><mdProjectedItem name="Share"/><mdProjectedItem name="Protocol"/><mdProjectedItem name="Capacity GB"/><mdProjectedItem name="Data Store"/><mdProjectedItem name="Data Store Capacity GB"/><mdProjectedItem name="Data Store Used GB"/><mdProjectedItem name="VM Guest"/><mdProjectedItem name="Provisioned GB"/><mdProjectedItem name="Used GB"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Cluster Name"><expression>[SQL1].[Cluster Name]</expression></dataItem><dataItem name="ESX Server"><expression>[SQL1].[ESX Server]</expression></dataItem><dataItem name="Storage"><expression>[SQL1].[Storage]</expression></dataItem><dataItem name="Share"><expression>[SQL1].[Share]</expression></dataItem><dataItem name="Protocol"><expression>[SQL1].[Protocol]</expression></dataItem><dataItem name="Capacity GB"><expression>[SQL1].[Capacity GB]</expression></dataItem><dataItem name="Data Store"><expression>[SQL1].[Data Store]</expression></dataItem><dataItem name="Data Store Capacity GB"><expression>[SQL1].[Data Store Capacity GB]</expression></dataItem><dataItem name="Data Store Used GB"><expression>[SQL1].[Data Store Used GB]</expression></dataItem><dataItemListSummary aggregateMethod="total" name="Total(Capacity GB)" refDataItem="Capacity GB"/><dataItemListSummary aggregateMethod="total" name="Total(Data Store Capacity GB)" refDataItem="Data Store Capacity GB"/><dataItemListSummary aggregateMethod="total" name="Total(Data Store Used GB)" refDataItem="Data Store Used GB"/><dataItem name="VM Guest"><expression>[SQL1].[VM Guest]</expression></dataItem><dataItem name="Provisioned GB"><expression>[SQL1].[Provisioned GB]</expression></dataItem><dataItem name="Used GB"><expression>[SQL1].[Used GB]</expression></dataItem><dataItem name="NFS Share Count" aggregate="total"><expression>IF([Protocol]='NFS') THEN (1) ELSE (0)</expression></dataItem><dataItem name="CIFS Share Count" aggregate="total"><expression>IF([Protocol]='CIFS') THEN (1) ELSE (0)</expression></dataItem><dataItem name="Total Datastore Capacity TB" aggregate="total"><expression>total(([Data Store Capacity GB]/1024) for report)</expression></dataItem><dataItem name="Total Provisioned TB" aggregate="total"><expression>Total(([Data Store Used GB]/1024) for report)</expression></dataItem><dataItem name="ESX Host Count"><expression>count(distinct [ESX Server])</expression></dataItem><dataItem name="Available TB"><expression>[Total Datastore Capacity TB]-[Total Provisioned TB]</expression></dataItem></selection>
		</query><query name="VM Guests">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL2">
			<sqlText>SELECT
dwh_inventory.hv_server.clustername as 'Cluster Name',
dwh_inventory.hv_virtual_machine.name as 'VM Guest',
dwh_inventory.hv_virtual_machine.provisionedCapacityMB/1024 as 'Provisioned GB',
dwh_inventory.hv_virtual_machine.usedCapacityMB/1024 as 'Used GB'

FROM 	dwh_inventory.hv_virtual_machine
JOIN	dwh_inventory.host
ON	dwh_inventory.hv_virtual_machine.hostid=dwh_inventory.host.id
JOIN	dwh_inventory.hv_server
ON	dwh_inventory.hv_server.hostid=dwh_inventory.host.id

GROUP BY dwh_inventory.hv_server.clustername, dwh_inventory.hv_virtual_machine.name
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Cluster Name"/><mdProjectedItem name="VM Guest"/><mdProjectedItem name="Provisioned GB"/><mdProjectedItem name="Used GB"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Cluster Name"><expression>[SQL2].[Cluster Name]</expression></dataItem><dataItem name="VM Guest"><expression>[SQL2].[VM Guest]</expression></dataItem><dataItem name="Provisioned GB"><expression>[SQL2].[Provisioned GB]</expression></dataItem><dataItem name="Used GB"><expression>[SQL2].[Used GB]</expression></dataItem></selection>
		</query></queries></report>